package com.ruoyi.common.mapper;

import com.ruoyi.common.pojo.AreaLiandong;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.HashMap;
import java.util.List;

@Mapper
public interface ComboxMapper {

    @Select("SELECT id AS value, tname AS label FROM sc_base_teacher_mst WHERE stat = 1")
    List<HashMap> getAllTacherCombox();
    @Select("SELECT id AS value, cname AS label\n" +
            "FROM sc_base_clazz_mst sbcm\n" +
            "WHERE status = 1")
    List<HashMap> getAllClazzCombox();

    List<AreaLiandong> getAllAreaLiandongCombox();
}
